package com.jfinal.aceadmin.controller;

import java.util.List;

import com.jfinal.aceadmin.model.MeetingList;
import com.jfinal.core.Controller;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;

public class DbDataCenterController extends Controller{
	

	public void dbdata(){
		
		//查询
		List<Record> loanProject = Db.find("select 项目编码,企业名称,业务品种,放款日期,放款金额  from queryProjectInfoForStatistics_Chinese where 放款日期 >='2015-01-01' order by 放款日期  desc");

		
		setAttr("loanProjectList", loanProject);
		
		
		
		//查询上会情况表
		
		List<Record> meetinglist = Db.find("select  a.project_code,trial_times,b.apply_service_type,c.corporation_name manager_recommend_sum,prime_committeeman,a.create_person from conference_trial a left join project b on a.project_code=b.project_code  left join consultation c on b.corporation_code=c.corporation_code where conference_code=3060 ");
		setAttr("MeetingList", meetinglist);
		
		
		render("dbdata.html");
	}

}
